UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OaAmuGfAT2OsrUMp/pht0uWBdHNPFJN+4TUC3Iq4Zj4='
WHERE
key_id = '749cc4dc082007521cb71db1b36a46e1bec6b756025d6b2b769b37ae7a96a9aa'
AND (
token = 'OaAmuGfAT2OsrUMp/pht0uWBdHNPFJN+4TUC3Iq4Zj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)