UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aqp1j+LRHEbQBo0ctL9SC/woZ1C55sBSGcUKbEw/sa0='
WHERE
key_id = 'db6796f36f19caa4ccc1bd591eb5cdd491a7a74fb40366d0fd26b2fb081aae14'
AND (
token = 'aqp1j+LRHEbQBo0ctL9SC/woZ1C55sBSGcUKbEw/sa0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)