UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Jr/j1qeL7BO+0C8xfi0kLw49OesOaySh9nyXRnaeZp0=' 
WHERE 
  key_id = 'c76a2844cb91d86e4b077418e48e63c6e666407fcbcb082191b45a88a4f55809' 
  AND (
    token = 'Jr/j1qeL7BO+0C8xfi0kLw49OesOaySh9nyXRnaeZp0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032