UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fmgHxaa83nGUI4JtA16VNd0GxO7cn2ISLLJTmffYiB4='
WHERE
key_id = 'e1915342cc6f9d6d97c9d9652e7596e2a31a8a84bd25185a1f09dcef7fa80acc'
AND (
token = 'fmgHxaa83nGUI4JtA16VNd0GxO7cn2ISLLJTmffYiB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)