UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aLy7poEqA9BBOGJQwJ9fXiJYtbbT6P0HA9WWP5q+QRY='
WHERE
key_id = 'db1d8bfb36e89ff1d5079e5f9d6044b279f0b79762ee48e9c3164a7e24acbd1d'
AND (
token = 'aLy7poEqA9BBOGJQwJ9fXiJYtbbT6P0HA9WWP5q+QRY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)