UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'f+HchoTTp6MxXE9Fdo3DSS8EYU6Ei2I2Uv9I97uoaSY=' 
WHERE 
  key_id = 'd6569cbf15d2caf43e87ef757aaab383bdc6956d91fa3667c663c32a433c0726' 
  AND (
    token = 'f+HchoTTp6MxXE9Fdo3DSS8EYU6Ei2I2Uv9I97uoaSY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00063