UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7Ya2hEXWS7fvI/kkpd35b8+LxeyaPDW+6UgdrOBbfHw=' 
WHERE 
  key_id = '671b65433c7e52b9ce0790dbf08124ba9bd4fceb3b5c47c6353f81c94cd9c966' 
  AND (
    token = '7Ya2hEXWS7fvI/kkpd35b8+LxeyaPDW+6UgdrOBbfHw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039