UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bRjTkDJYrHRuvESnd6ZjvKw8+7YTD/UK6qDDSXvtScc='
WHERE
key_id = '0b473655e02f7b22d5da5ce1d85cd298cc02b1a5e5807a6da562e6b37bb06797'
AND (
token = 'bRjTkDJYrHRuvESnd6ZjvKw8+7YTD/UK6qDDSXvtScc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)