UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'M1bdw8E/iyKmjZ7QMn+D1syVy6roI7OwihEGcCurJ5g=' 
WHERE 
  key_id = 'c445d9602a410f2f04c31b2c7c9bfaa2c09a79ea428cefe6a4175c0de9d892ed' 
  AND (
    token = 'M1bdw8E/iyKmjZ7QMn+D1syVy6roI7OwihEGcCurJ5g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028