UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4vkxdRFeJpphxqHOA7R8Xk5z3Tzc6tDZHq2gha6/Sg0='
WHERE
key_id = 'd13d3cfb35f4a86dd6deba2bf2e3fc2bdb97d972b4b5ce8e475eb0fe6dc5589b'
AND (
token = '4vkxdRFeJpphxqHOA7R8Xk5z3Tzc6tDZHq2gha6/Sg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)