UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XO6v+SwiPJcqFUi7+RJ6dA/5NDWL5NnJc71MtkJz+9o='
WHERE
key_id = '22c3e7b07497c8e16ab1e5fa6f2710fce0671f6ff2ea9cc62435f92760a1bb29'
AND (
token = 'XO6v+SwiPJcqFUi7+RJ6dA/5NDWL5NnJc71MtkJz+9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)