UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/gNRSx2PTXu5n56nY9DmU2P7gEys+AIBMF7G4/r0CiQ=' 
WHERE 
  key_id = '20cb9c3a9c8a65ca1dd28963d2ad0ac599ed607b34d01cb640119f2d34033b20' 
  AND (
    token = '/gNRSx2PTXu5n56nY9DmU2P7gEys+AIBMF7G4/r0CiQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021