UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LOFTnKySLyYtUKDBvnMUGaMNUBmyEFpi0d3XZ/aTbbc='
WHERE
key_id = 'aa3c82b0d4598553119bbb2f863db9928e36a738ef4f2b08f44ac9e4e7210d89'
AND (
token = 'LOFTnKySLyYtUKDBvnMUGaMNUBmyEFpi0d3XZ/aTbbc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)