UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RShv9p9S/7Um8o2lAzk2RD3AFlhXmAazhDpITpTDnsM=' 
WHERE 
  key_id = 'bb9e9bb670316f824f0a7e11d14b5d74078a0f5cc1b5fef4651032e43bb11969' 
  AND (
    token = 'RShv9p9S/7Um8o2lAzk2RD3AFlhXmAazhDpITpTDnsM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00016