UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KrLZGhpDH5rE3MObNXjjiNkn1GPnUADyNNM11Ex6PRg='
WHERE
key_id = '89174f621609aa35842eeb9ee0c5bb3ee13cd8bcc572619e3785843968a76e25'
AND (
token = 'KrLZGhpDH5rE3MObNXjjiNkn1GPnUADyNNM11Ex6PRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)