UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ODpxLSqQ23LVHH9GLM9md92g5XZxn1oID3mZzOAQccE=' 
WHERE 
  key_id = 'dee3db21c67394827f9884cfaf4f63ebe0fb7ec93363429f00b3f2359219d513' 
  AND (
    token = 'ODpxLSqQ23LVHH9GLM9md92g5XZxn1oID3mZzOAQccE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038