UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CiVqYeqX6GzKVVFcgyHC9J0Isw+r8gCfuDlzHbflUAA='
WHERE
key_id = '77b4a71ddf438a8289d106594bd64347a6962dee18a18ad6b9c100a2025a94b4'
AND (
token = 'CiVqYeqX6GzKVVFcgyHC9J0Isw+r8gCfuDlzHbflUAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)