UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'C7GoJbMeAwcFzRBv/TwztSplve4sJz9l6dlZlkNZwgg=' 
WHERE 
  key_id = '57a3379f06319ed77f999cb1af64b655a290d2bcece47a8e5bb3de7dda9f702d' 
  AND (
    token = 'C7GoJbMeAwcFzRBv/TwztSplve4sJz9l6dlZlkNZwgg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031