UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4Vht5UHn8mKiwFxVrMHwM8NZCmzy2zwipigE3/HLhRQ=' 
WHERE 
  key_id = '6289002cd2cd6463c862295eeb11096ad22d892954fe121057b96ccd76a39399' 
  AND (
    token = '4Vht5UHn8mKiwFxVrMHwM8NZCmzy2zwipigE3/HLhRQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046