UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZHiF9UA2ExIQeJ/WR2Vy3btig5HK2dj7BMWV/wfjQHQ='
WHERE
key_id = 'd00187e1b534c5c7226d8d82bba66c5a568a20c4be41acc19dd761803417a38f'
AND (
token = 'ZHiF9UA2ExIQeJ/WR2Vy3btig5HK2dj7BMWV/wfjQHQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)