UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RB2XUS9nO7+zO1gLFWmyTwGjmNykAY9wmzveeIfYo04='
WHERE
key_id = 'c5d6919c4bcb3641cf31172d9583fd19dd8f26ec249dd20f4ae1f595367e07b8'
AND (
token = 'RB2XUS9nO7+zO1gLFWmyTwGjmNykAY9wmzveeIfYo04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)