UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fObZ3E62Q7icbHcRepx+q7nbcCpD1ttrjdIg4bw3I0g='
WHERE
key_id = 'ab94346a7d42f4b1d60bb14363a835cb19a353f91a53871872d2e794a352c1e1'
AND (
token = 'fObZ3E62Q7icbHcRepx+q7nbcCpD1ttrjdIg4bw3I0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)