UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AwQXTWxdH2tCAmGt3UADwY0XpYDlz7NU3i7E5a2sYEg='
WHERE
key_id = '065d29be8dc694c02b83748fa0d523ce0f3e87002d85f4fea8501603c13e96e4'
AND (
token = 'AwQXTWxdH2tCAmGt3UADwY0XpYDlz7NU3i7E5a2sYEg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)