UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Gk0LSIzwzuofddEpq7lxDl9BYwtwEE64LmyzBYllhoc=' 
WHERE 
  key_id = 'c8294f871b4b6ea3a8b99b889b7326dc3e5c10367a1ac22f619e671d382b8783' 
  AND (
    token = 'Gk0LSIzwzuofddEpq7lxDl9BYwtwEE64LmyzBYllhoc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020