UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1eFq8I/D4C6tsMDdw6jQxrBDmLqZMuGP/m8OT7alNbQ=' 
WHERE 
  key_id = 'b31765cf78606aec70670c78357b38934887c4ffcdf1a7d9972c7c77258c0512' 
  AND (
    token = '1eFq8I/D4C6tsMDdw6jQxrBDmLqZMuGP/m8OT7alNbQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00015