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