UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's7TZta3iHIE1biP6dbk+J++4WzHME4swzvpFCj0WueI='
WHERE
key_id = '0160190fd3e5389b1b15cfa3b93cbb2e6e98fdda4871d839d24ae35b80c6a04e'
AND (
token = 's7TZta3iHIE1biP6dbk+J++4WzHME4swzvpFCj0WueI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)