UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bWRGEUp2zsWs5g9LhcC76ZY/QuKMsTrB4VL6twGRoag='
WHERE
key_id = '6770163a11381033379ffae35f300ef1e220b21e3ed4ea80b43284aa231f819a'
AND (
token = 'bWRGEUp2zsWs5g9LhcC76ZY/QuKMsTrB4VL6twGRoag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)