UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0VLC4xoc+qDRqNNyjnQb+GRAiSm6A1sayL+KJoMV5kQ=' 
WHERE 
  key_id = '0bfe768c8a91fd5f3c688e28a0543a18ace8a854d6f23425079bf430f31f8b61' 
  AND (
    token = '0VLC4xoc+qDRqNNyjnQb+GRAiSm6A1sayL+KJoMV5kQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00049