UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UW6qwuL9YbAWQkUMHNCsbPDw6VgGIVh5bzgWo6sSNBA='
WHERE
key_id = '6bd4092889ea3a47a7c4b39fd9c6a225b751f042f63dfac0cc069f5641e41ea4'
AND (
token = 'UW6qwuL9YbAWQkUMHNCsbPDw6VgGIVh5bzgWo6sSNBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)