UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'uD7C98/iEJm3urfYCsoUwrQ+rOFnvGrUQGRU3UgxV/w=' 
WHERE 
  key_id = '0cbde28de85afc48d3df15610d0ca814be90beb3f09f9b90cae5e3abbb3ced39' 
  AND (
    token = 'uD7C98/iEJm3urfYCsoUwrQ+rOFnvGrUQGRU3UgxV/w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029