UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZYpulj4q1v7qNOQzKVyxV9Jj4dkjCjXhCBIdRA02puA='
WHERE
key_id = '3fd75921ab4e152d032ce913e339f3be8d7bc9f04b6b852c440fe40703306123'
AND (
token = 'ZYpulj4q1v7qNOQzKVyxV9Jj4dkjCjXhCBIdRA02puA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)