UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'iVJ50tx/uPWFAIW6QX6GZd/r7WxxPCiSZh/vE7gOqM8=' 
WHERE 
  key_id = '617b86689b7765ac68edf8293c9271b6d65f45c897352d81032b672e40aebf47' 
  AND (
    token = 'iVJ50tx/uPWFAIW6QX6GZd/r7WxxPCiSZh/vE7gOqM8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032