UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5kMxDKFeB9Xt6Z/WVNv1ku/cklVtWCe3SGF1fpLIzRs='
WHERE
key_id = 'a6c2a1324ae7c036633ddcaa78ddf05506ecdad92356fd032d185b1f4b50c352'
AND (
token = '5kMxDKFeB9Xt6Z/WVNv1ku/cklVtWCe3SGF1fpLIzRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)