UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8P9MP8zIDMfg3WkViKeFv64m5cMrP6ZFP/9MT2QvHXY='
WHERE
key_id = 'd454e3cd33fba91e7ccd1becccaee0afb9192c7a5290a189f19812491a8d94a7'
AND (
token = '8P9MP8zIDMfg3WkViKeFv64m5cMrP6ZFP/9MT2QvHXY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)