UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'S6MOEPDVHz7HMxTqa2NcFsE2aZNR6fLyUKFi0xAkSMo=' 
WHERE 
  key_id = 'c543fc839c87ea9a510c3e9da43eb30b68c2065570d70d4209796c921e69b87b' 
  AND (
    token = 'S6MOEPDVHz7HMxTqa2NcFsE2aZNR6fLyUKFi0xAkSMo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047