UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QdQY3ENz7hafpM+tMHrNG7qzVmkkPTuiqE98VAztqwI='
WHERE
key_id = '5cc1e263db93aae1b477c9a244d0c3346313effd5e71221d558af1c5490f2efd'
AND (
token = 'QdQY3ENz7hafpM+tMHrNG7qzVmkkPTuiqE98VAztqwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)