UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Ot2aF7m5hWyMY4FVEm+MSc11vD4E9z/xboj3yXCLlIw=' 
WHERE 
  key_id = 'd710f5264171a2a2c62ffbe606c97a4e2b5dcdf2521c4b00ae0ad9f6d745875e' 
  AND (
    token = 'Ot2aF7m5hWyMY4FVEm+MSc11vD4E9z/xboj3yXCLlIw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028