UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0DTkdTbZ35Nzuo1zlLX705TN3/xp1vu9om3AhuOdGAc=' 
WHERE 
  key_id = '65f9dc52787d64131ca97c77073b4e46370ca34a328c0d9150604876945f57e9' 
  AND (
    token = '0DTkdTbZ35Nzuo1zlLX705TN3/xp1vu9om3AhuOdGAc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043