UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A5+rX3Ix8aX7zXtn/3+HlhuTWiQTbk7YZ9LjfJdmpf0='
WHERE
key_id = '3b93ff0bec2665bb4ba60934329f2a52063a74777074258997c673a92392e5bf'
AND (
token = 'A5+rX3Ix8aX7zXtn/3+HlhuTWiQTbk7YZ9LjfJdmpf0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)