UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NVWNWMjfo9b7I5JGhzG2gYPzAyrIDX1gwA8olUiEtr0='
WHERE
key_id = 'dcbbe662ae1861caea29c532b88573ef59ccb1197fa2cce4f37e3903ae1b52ff'
AND (
token = 'NVWNWMjfo9b7I5JGhzG2gYPzAyrIDX1gwA8olUiEtr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)