UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ap4gKpdnces9Y9a5yy5tvbtiRFSc7N22OPv19W6TsYg='
WHERE
key_id = 'd98bfa2c57488da545198cd523f3856dfb388f00a0e740077a9d5f912e86f3e2'
AND (
token = 'ap4gKpdnces9Y9a5yy5tvbtiRFSc7N22OPv19W6TsYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)