UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BhkVqgoaxd7MQI0OPVYaiqs0v/x9HHeLIgjWeOgwdYs=' 
WHERE 
  key_id = 'c702bc2d1b9e3d15f5cf8ee45e957ebf3eb904551793763c675703fb1e3a4307' 
  AND (
    token = 'BhkVqgoaxd7MQI0OPVYaiqs0v/x9HHeLIgjWeOgwdYs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021