UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gF/uDpaVCM6mbgL/cwbWniOlUB2alRVyA1EvqEqUUA8='
WHERE
key_id = '241f21e7f46af46d5ee954d351822babf845aedeff814c62e158b0b4b2971909'
AND (
token = 'gF/uDpaVCM6mbgL/cwbWniOlUB2alRVyA1EvqEqUUA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)