UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8B2+uRIThNFZxd3lDxsCR3RpGmPfFJou8L7d0KSw7x4='
WHERE
key_id = 'b4698ecb62a119b20a608b7daf79f96beccee7a70543a7f992604d275f362e59'
AND (
token = '8B2+uRIThNFZxd3lDxsCR3RpGmPfFJou8L7d0KSw7x4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)