UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zt/i1m0lXqPqryva1rVSivXC9+azMEtvQU4tFPurP+s='
WHERE
key_id = '13e5024dba6eabe152cdcf7f5fbcc2d80b88345757792d66cc715e746e7b825f'
AND (
token = 'zt/i1m0lXqPqryva1rVSivXC9+azMEtvQU4tFPurP+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)