UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QQBSVeFMVE6vLEm5S1O2tNBEFw45XJK5C0aNnmeIqdI='
WHERE
key_id = '75f32f0ff40c91acf5662dea6716926f0e9b39f9316cbfa18507a79f5451812e'
AND (
token = 'QQBSVeFMVE6vLEm5S1O2tNBEFw45XJK5C0aNnmeIqdI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)