UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9mdBu0DD6KsqNYH7BhKnfXPogcrCYbigT2EyUNMoYlY='
WHERE
key_id = '14dd77a6199c01b1ab15afb7639d3aa8a4af55f80a0f2766b3d1d4decc398824'
AND (
token = '9mdBu0DD6KsqNYH7BhKnfXPogcrCYbigT2EyUNMoYlY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)