UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pMCH5xOB3+w1+ZY+RcKj6VKwJ3InCc2dPo7Em04z2rk=' 
WHERE 
  key_id = 'c95bfb3d707a4575efc34f0a641ca4cb1c5816ca37634760c8852ef11afdb2a0' 
  AND (
    token = 'pMCH5xOB3+w1+ZY+RcKj6VKwJ3InCc2dPo7Em04z2rk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021