UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XulpkyGjFKTwsc/NGHiCScXBsgPR3E4HYHHuE50ocDI=' 
WHERE 
  key_id = 'ecdeb3f7f6057f4894f2b00a26d45fbe685c76ad0a0c76bd443790c7f29b46c1' 
  AND (
    token = 'XulpkyGjFKTwsc/NGHiCScXBsgPR3E4HYHHuE50ocDI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048