UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/HjVXQIgbeqnn/EX2w7rSklXHyH4p9jR/NLFmsljIBA=' 
WHERE 
  key_id = '2d3a912d988e5919a00a7abd0d34d312da5fdfc3a8aac2c752256d4b9a0eea23' 
  AND (
    token = '/HjVXQIgbeqnn/EX2w7rSklXHyH4p9jR/NLFmsljIBA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036