UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qmTWxEtxv84sUk5BCDL8uCczo1M0YLaw+H/43X3LM38=' 
WHERE 
  key_id = '2a1b04128d33afd0ecb105052ff82cae4fbecffe5eb0227fb8e6618f9a9d2dff' 
  AND (
    token = 'qmTWxEtxv84sUk5BCDL8uCczo1M0YLaw+H/43X3LM38=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031