UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tjUw0uYZ/x1rjHCHUA0sBWVQaoRKqT7oPQwFvgAc9z4='
WHERE
key_id = 'e88ee343a31e3b255cdcad9b65544b70ec7878c41ae2e81564820e6160b74f7e'
AND (
token = 'tjUw0uYZ/x1rjHCHUA0sBWVQaoRKqT7oPQwFvgAc9z4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)