UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QckSB8m8yk9hVePeRms6nC8OIMjzqzrujtMAyCvzBE8='
WHERE
key_id = '482182e03f6d0f0081046a9495b2bab30d8d72b5c52433d375d0bc0a88767878'
AND (
token = 'QckSB8m8yk9hVePeRms6nC8OIMjzqzrujtMAyCvzBE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)