UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UbO2Tf6duCLdwEh5b0BP/EjHI+xyZ1KhITFdwmejB8s=' 
WHERE 
  key_id = '5e6031fa6b522a5f063bd8e03f9614d7d27aa5fff724325e804647746c3b714c' 
  AND (
    token = 'UbO2Tf6duCLdwEh5b0BP/EjHI+xyZ1KhITFdwmejB8s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021