UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J8w1Ob1V3i21v40hKjlEc8sGsUm7fz9WrH4WamxOLo4='
WHERE
key_id = '313e507c5191c93c4284d06bcad343beea9c1af2e5dbbebf7642b9d400eb3259'
AND (
token = 'J8w1Ob1V3i21v40hKjlEc8sGsUm7fz9WrH4WamxOLo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)