UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '01+3WOAwyIzmLhm/zbs3K7KXE3E6vYkJunCvhlHUaS8='
WHERE
key_id = '3bfe1888a0882c95d6d92f8a80f0f5d0a48d15e49db38c7c5c205f575ce54533'
AND (
token = '01+3WOAwyIzmLhm/zbs3K7KXE3E6vYkJunCvhlHUaS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)