UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DMIm+Epw3IIQBzJAqE7UtmRghjYAUlT4XGsbUF7Jk/g='
WHERE
key_id = '8e7c63901de9da351e453ab36317afdd846b9de7296f84d2b6135578ce4a2e74'
AND (
token = 'DMIm+Epw3IIQBzJAqE7UtmRghjYAUlT4XGsbUF7Jk/g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)