UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1oqT6mBKmPy20szB9wT8LiLPy4Kmbs9gYT4vk96aNak='
WHERE
key_id = 'b8344646e4bb5097daeac3e2cd017bc37c365f5a80fcbe2fd1cb2fbceadc6993'
AND (
token = '1oqT6mBKmPy20szB9wT8LiLPy4Kmbs9gYT4vk96aNak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)