UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6e9Sb+ve3xB5hMgyg/wwAHHVqzVzfVC7f8zumcjsT8w='
WHERE
key_id = 'c4faf163591744ea146ed835247c913f43be2c96bccd7f14aa6e7bf0da19a8d6'
AND (
token = '6e9Sb+ve3xB5hMgyg/wwAHHVqzVzfVC7f8zumcjsT8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)