UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D1+kSk0WvoJZL+RxtICGoPVJSVoq5lWat+FNHYhN9LQ='
WHERE
key_id = '12a11b1abf40f46dbf896c67c1c8d0c74a26dd54f54e3acdac60ce1edc0e9dcc'
AND (
token = 'D1+kSk0WvoJZL+RxtICGoPVJSVoq5lWat+FNHYhN9LQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)