UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zXuAr2elEVKrKkQKTdxOj+V6tdro00fj8BDw2u9jNk8='
WHERE
key_id = '99b600cc88ee9cebd53e16fc999612ea61ad5c509330718cf492c609a406d2cb'
AND (
token = 'zXuAr2elEVKrKkQKTdxOj+V6tdro00fj8BDw2u9jNk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)